Eric Law ✭✭✭✭✭✭

Overview

Overview

Roles	Member
Badges	21

About Me

About Me

Not much happening here, yet.

Analytics

362

Posts

290

Visits

1.3k

Points

Jun 15, 2022

Join Date

Jun 6, 2024

Last Active

Reactions

• Insightful 14

  14
• Vote Up 16

  16
• Awesome 30

  30

• Activity
• Discussions1
• Comments361

• Re: How to review a column of dates and count the rows that are not a date

  Eric Law

  12/13/23
  Try this instead =COUNTIFS({Hub Name}, [Hub Name]@row, {Node List - Node Activation Date}, NOT(ISDATE(@cell)))
  2 ·

• Re: SUMIF for terms in multiple selection drop down

  Eric Law

  10/27/23
  @kathryn.marini are you the blacked out the price? If so, you may want to do something a little different. My recommendation is to create summaries for the prices, so you can update the prices easier…
  1 ·

• Re: Has anyone figured a workaround to show all pending approval requests?

  Eric Law

  10/19/23
  @April Locke CIG You can do a filter saying if there is "Pending" on any approval columns, it displays.
  1 ·

• Re: Formula - Helper Column Flag if Duplicate

  Eric Law

  09/25/23
  @Estephania Here is an easier formula for you, =IF(COUNTIF([Employee ID]:[Employee ID],[Employee ID]@row)>1,1,0) Or you can throw in an iferror too =IFERROR( IF(COUNTIF([Employee ID]:[Employee ID]…
  1 ·

• Re: Identifying Duplicates

  Eric Law

  09/21/23
  Hello @CAS You will need a new column. You can use this formula, =COUNTIF([Invoice No]:[Invoice No],[Invoice No]@row)
  1 ·

Next